{smcl}
{right:version 1.1}
{title:Title}

{phang}
{cmd:txls} {hline 2} tranforming excel files between xls and xlsx
 

{title:Syntax}

{p 8 16 2}
{cmd: txls} {p_end}

{p 8 16 2}
{cmd: txls} {it:pathtoxlsx[pathtoxls]} {cmd:,}  [{it:todir(pathforcsv) xls}] {p_end}

{p 8 16 2}
{cmd: txls} {it:directory} {cmd:,}  [{it:todir(pathforcsv) xls}] {p_end}



{title:Options}

{p 4 4 2}

{synoptset 20 tabbed}{...}
{synopthdr}
{synoptline}

{synopt:{opt todir(pathforcsv)}}specifies the directory to store the csv files in your PC; if missing, 
a CSV folder is generated in the parent path of path{p_end} 


{synopt:{opt xls}}specifies tranforming *.xlsx to *.xls when converting many files in a folder; by default, tranforming *.xls to *.xlsx. {p_end} 


{title:Example(s)}

{p 4 4 2}

{p 4 4 2}
Converting all xls/xlsx files in the specified directory; csv files are stored in C:\tmp\CSV.

    . txls C:\tmp

{p 4 4 2}
Converting a xls/xlsx file in the local directory.

    . txls C:\tmp\test.xls, todir(C:\tmp\csv)

{p 4 4 2}
Using Dialog-box mode

	. txls


{title:Author}

{p 4 4 2}
Kerry Du     {break}
Xiamen University      {break}
Email:kerrydu@xmu.edu.cn     {break}
